﻿CREATE TABLE [dbo].[Employee_CompanyMove] (
    [id]              INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Eid]             INT            NOT NULL,
    [EName]           NVARCHAR (50)  NOT NULL,
    [BCompanyId]      INT            NOT NULL,
    [ACompanyId]      INT            NOT NULL,
    [BCompanyName]    NVARCHAR (200) CONSTRAINT [DF_Employee_CompanyMove_BCompanyName] DEFAULT ('') NULL,
    [ACompanyName]    NVARCHAR (200) CONSTRAINT [DF_Employee_CompanyMove_ACompanyName] DEFAULT ('') NULL,
    [BDepartmentId]   INT            NULL,
    [ADepartmentId]   INT            NULL,
    [BDepartmentName] NVARCHAR (200) CONSTRAINT [DF_Employee_CompanyMove_BDepartmentName] DEFAULT ('') NULL,
    [ADepartmentName] NVARCHAR (200) CONSTRAINT [DF_Employee_CompanyMove_ADepartmentName] DEFAULT ('') NULL,
    [BZhiWu]          NVARCHAR (50)  NULL,
    [AZhiWu]          NVARCHAR (50)  NULL,
    [Reason]          VARCHAR (MAX)  NULL,
    [Proposer]        NVARCHAR (50)  NULL,
    [ApplionTime]     DATETIME       NULL,
    [Audit]           BIT            CONSTRAINT [DF_Employee_Grade_FirstAudit] DEFAULT ((0)) NULL,
    [Memo]            VARCHAR (MAX)  NULL,
    [AuditPerson]     NVARCHAR (50)  NULL,
    [AuditTime]       DATETIME       NULL,
    [Execdate]        DATETIME       NULL,
    [IsExec]          BIT            CONSTRAINT [DF_Employee_CompanyMove_IsExec_1] DEFAULT ((0)) NULL,
    [BPid]            INT            NULL,
    [BCid]            INT            NULL,
    [APid]            INT            NULL,
    [ACid]            INT            NULL,
    [PostId]          INT            NULL,
    [PostName]        NVARCHAR (50)  CONSTRAINT [DF_Employee_CompanyMove_PostName] DEFAULT ('') NULL,
    [GradeId]         INT            NULL,
    [GradeName]       NVARCHAR (50)  CONSTRAINT [DF_Employee_CompanyMove_GradeName] DEFAULT ('') NULL,
    [XZJB]            NVARCHAR (50)  NULL,
    CONSTRAINT [PK_Employee_Grade] PRIMARY KEY CLUSTERED ([id] ASC)
);

